package com.micro.school.edu.mapper;


import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.micro.school.edu.domain.SchoolCollege;
import com.micro.school.edu.domain.vo.SchoolCollegeVo;
import com.micro.school.system.api.domain.vo.SchoolCollegeVos;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;


import java.util.List;

/**
 * 学院信息Mapper接口
 *
 * @author rakic
 * @date 2025-08-06
 *
 */

public interface SchoolCollegeMapper extends BaseMapper<SchoolCollege>
{
    /**
     * 查询学院信息
     *
     * @param id 学院信息主键
     * @return 学院信息
     */
    public SchoolCollegeVo selectSchoolCollegeById(Long id);

    /**
     * 查询学院信息列表
     *
     * @param schoolCollegeVo 学院信息
     * @return 学院信息集合
     */
    public List<SchoolCollegeVo> selectSchoolCollegeList(SchoolCollegeVo schoolCollegeVo);

    /**
     * 新增学院信息
     *
     * @param schoolCollege 学院信息
     * @return 结果
     */
    public int insertSchoolCollege(SchoolCollege schoolCollege);

    /**
     * 修改学院信息
     *
     * @param schoolCollege 学院信息
     * @return 结果
     */
    public int updateSchoolCollege(SchoolCollege schoolCollege);

    /**
     * 删除学院信息
     *
     * @param id 学院信息主键
     * @return 结果
     */
    public int deleteSchoolCollegeById(Long id);

    /**
     * 批量删除学院信息
     *
     * @param ids 需要删除的数据主键集合
     * @return 结果
     */
    public int deleteSchoolCollegeByIds(Long[] ids);

    List<String> getAllCollegeNameList(SchoolCollegeVos schoolCollegeVos);

    SchoolCollegeVos selectSchoolCollegeByIds(@Param("id")Long id,@Param("tenantId")String tenantId);

    List<SchoolCollegeVos> getAllCollegeNameLists(SchoolCollegeVos schoolCollegeVos);

    List<SchoolCollege> selectSchoolCollegeByName(@Param("collegeName")String collegeName,@Param("tenantId")String tenantId);
}
